<?php
  //DO NOT TOUCH THIS FILE!!! -ZHI
  
  include('./varsandfunctions.php');
  
  //Create users
  createNewUser("janedoe","password", "1,2");
  
  //Lists
  createNewList("Fall Quarter 2009 Classes", "Academic", "1,2,3,4");
  createNewList("Favorite Campus Eateries", "Food", "5,6,7");
  
  //Locations
  createNewLocation("CS 147 Lecture", 10, "Academic", "13:15", "14:05");
  createNewLocation("CS 147 Studio", 11, "Academic", "14:15", "15:05");
  createNewLocation("History 106A Section", 5, "Academic", "15:15", "16:05");
  createNewLocation("CS 147L", 12, "Academic", "17:15", "18:30");
  
  createNewLocation("Thai Cafe", 3, "Food");
  createNewLocation("Olives", 5, "Food", "11:30", "14:30");
  createNewLocation("Coupa Cafe", 12, "Food");
  
  //Buildings
  createNewBuilding("Gates Computer Science"); //1
  createNewBuilding("Building 380"); //2 Math Sloan Hall
  createNewBuilding("Building 420"); //3 Psych Jordan Hall
  createNewBuilding("Building 460"); //4 English/PWR Margaret Jacks Hall
  createNewBuilding("Building 200"); //5 Lane Hall History
  createNewBuilding("Building 160"); //6 Wallenberg Hall
  createNewBuilding("Building 120"); //7 McClatchy Hall, Sociology Communication
  createNewBuilding("Varian Physics Lab"); //8
  createNewBuilding("Varian Physics and Astrophysics"); //9
  createNewBuilding("Hewlett Teaching Center"); //10
  createNewBuilding("Building 524"); //11
  createNewBuilding("Y2E2"); //12
  createNewBuilding("Memorial Auditorium"); //13
  createNewBuilding("The Oval"); //14
  createNewBuilding("Arrillaga Alumni Center"); //15
  createNewBuilding("West Lagunita"); //16
  createNewBuilding("Old Union"); //17
  createNewBuilding("Stanford Bookstore"); //18
  
  
  //People
  createNewPerson("Jay Borenstein", "Gates 191", 1);
  createNewPerson("Jerry Cain", "Gates 192", 1);
  createNewPerson("David Cheriton", "Gates 439", 1);
  createNewPerson("Hector Garcia-Molina", "Gates 434", 1);
  createNewPerson("Mike Genesereth", "Gates 220", 1);
  createNewPerson("Patrick Hanrahan", "Gates 370", 1);
  createNewPerson("Scott Klemmer", "Gates 384", 1);
  createNewPerson("Don Knuth", "Gates 477", 1);
  createNewPerson("Daphne Koller", "Gates 142", 1);
  createNewPerson("Monica Lam", "Gates 307", 1);
  createNewPerson("Philip Levis", "Gates 358", 1);
  createNewPerson("Fei Fei Li", "Gates 246", 1);
  createNewPerson("Zohar Manna", "Gates 481", 1);
  createNewPerson("Chris Manning", "Gates 158", 1);
  createNewPerson("David Mazieres", "Gates 290", 1);
  createNewPerson("John McCarthy", "Gates 208", 1);
  createNewPerson("Nick Parlante", "Gates 190", 1);
  createNewPerson("Serge Plotkin", "Gates 472", 1);
  createNewPerson("Bob Plummer", "Gates 178", 1);
  createNewPerson("Eric Roberts", "Gates 202", 1);
  createNewPerson("Tim Roughgarden", "Gates 462", 1);
  createNewPerson("Mehran Sahami", "Gates 180", 1);
  createNewPerson("Jeff Ullman", "Gates 433", 1);
  createNewPerson("Jennifer Widom", "Gates 276", 1);
  createNewPerson("Terry Winograd", "Gates 388", 1);
  createNewPerson("Patrick Young", "Gates 194", 1);
  createNewPerson("Julie Zelenski", "Gates 188", 1);
  
  //Something in the following inserts is corrupting the People table.
  //Either that or a certain size exceeded is causing it.
  
  // createNewPerson("Alex Aiken", "Gates 411", 1);
  // createNewPerson("Dan Boneh", "Gates 475", 1);
  // createNewPerson("Vaughan Pratt", "Gates 478", 1);
  // createNewPerson("Mendel Rosenblum", "Gates 309", 1);
  // createNewPerson("Gio Wiederhold", "Gates 436", 1);
  // createNewPerson("Yoav Shoham", "Gates 140", 1);
  // createNewPerson("Sebastian Thrun", "Gates 154", 1);
  // createNewPerson("Marc Levoy", "Gates 366", 1);
  // createNewPerson("Bill Dally", "Gates 301", 1);
  // createNewPerson("David Bill", "Gates 344", 1);
  // createNewPerson("Dawson Engler", "Gates 314", 1);
  // createNewPerson("Ron Fedkiw", "Gates 207", 1);
  // createNewPerson("Edward Feigenbaum", "Gates 237", 1);
  // createNewPerson("Richard Fikes", "Gates 505", 1);
  // createNewPerson("Jeff Heer", "Gates 375", 1);
  // createNewPerson("Mark Horowitz", "Gates 306", 1);
  // createNewPerson("Oussama Khatib", "Gates 144", 1);
  // createNewPerson("Vladlen Koltun", "Gates 374", 1);
  // createNewPerson("Christos Kozyrakis", "Gates 304", 1);
  // createNewPerson("Jure Leskovec", "Gates 418", 1);
  // createNewPerson("Edward McCluskey", "Gates 235", 1);
  // createNewPerson("Nick McKeown", "Gates 340", 1);
  // createNewPerson("John Mitchell", "Gates 476", 1);
  // createNewPerson("Subhasish Mitra", "Gates 333", 1);
  // createNewPerson("Andrew Ng", "Gates 156", 1);
  // createNewPerson("Nils Nilsson", "Gates 135", 1);
  // createNewPerson("Kunle Olukotun", "Gates 302", 1);
  // createNewPerson("John Ousterhout", "Gates 310", 1);
  
  // createNewPerson("Albert Bandura", "420-134", 3);
  // createNewPerson("Lera Boroditsky", "420-300", 3);
  // createNewPerson("Laura Carstensen", "420-167", 3);
  // createNewPerson("Herbert Clark", "420-302", 3);
  // createNewPerson("Carol Dweck", "420-240", 3);
  // createNewPerson("Jennifer Eberhardt", "420-254", 3);
  // createNewPerson("Anne Fernald", "420-202", 3);
  // createNewPerson("Ian Gotlib", "420-175", 3);
  // createNewPerson("Kalanit Grill-Spector", "420-414", 3);
  // createNewPerson("James Gross", "420-436", 3);
  // createNewPerson("Leonard Horowitz", "420-132", 3);
  // createNewPerson("Susan Johnson", "420-216", 3);
  // createNewPerson("Brian Knutson", "420-470", 3);
  // createNewPerson("Mark Lepper", "420-382", 3);
  // createNewPerson("Ellen Markman", "420-282", 3);
  // createNewPerson("Hazel Markus", "420-256", 3);
  // createNewPerson("Jay McClelland", "420-344", 3);
  // createNewPerson("Samuel McClure", "420-448", 3);
  // createNewPerson("Dale Miller", "420-342", 3);
  // createNewPerson("Benoit Monin", "420-388", 3);
  // createNewPerson("Michael Ramscar", "420-356", 3);
  // createNewPerson("Lee Ross", "420-380", 3);
  // createNewPerson("Claude Steele", "420-390", 3);
  // createNewPerson("Ewart Thomas", "420-476", 3);
  // createNewPerson("Jeanne Tsai", "420-171", 3);
  // createNewPerson("Anthony Wagner", "420-402", 3);
  // createNewPerson("Greg Walton", "420-244", 3);
  // createNewPerson("Brian Wandell", "420-484", 3);
  // createNewPerson("Jeffrey Wine", "420-450", 3);
  // createNewPerson("Gordon Bower", "420-314", 3);
  // createNewPerson("Albert Hastorf", "420-210", 3);
  // createNewPerson("Barbara Tversky", "420-334", 3);
  // createNewPerson("Philip Zimbardo", "420-246", 3);
?>